Dataset statistics
| Number of variables | 44 |
|---|---|
| Number of observations | 398194 |
| Missing cells | 515165 |
| Missing cells (%) | 2.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 133.7 MiB |
| Average record size in memory | 352.0 B |
Variable types
| CAT | 24 |
|---|---|
| NUM | 17 |
| BOOL | 3 |
Reproduction
| Analysis started | 2020-07-07 14:53:46.781985 |
|---|---|
| Analysis finished | 2020-07-07 14:56:23.166784 |
| Duration | 2 minutes and 36.38 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
INJURIES_UNKNOWN has constant value "0.0" | Constant |
CRASH_DATE has a high cardinality: 259780 distinct values | High cardinality |
DATE_POLICE_NOTIFIED has a high cardinality: 307208 distinct values | High cardinality |
STREET_NAME has a high cardinality: 1500 distinct values | High cardinality |
LOCATION has a high cardinality: 183467 distinct values | High cardinality |
Unnamed: 0 is highly correlated with df_index | High correlation |
df_index is highly correlated with Unnamed: 0 | High correlation |
LONGITUDE is highly correlated with LATITUDE | High correlation |
LATITUDE is highly correlated with LONGITUDE | High correlation |
LANE_CNT has 205498 (51.6%) missing values | Missing |
INTERSECTION_RELATED_I has 309667 (77.8%) missing values | Missing |
LANE_CNT is highly skewed (γ1 = 344.7025902) | Skewed |
LATITUDE is highly skewed (γ1 = -111.1077614) | Skewed |
LONGITUDE is highly skewed (γ1 = 120.2509699) | Skewed |
CRASH_DATE is uniformly distributed | Uniform |
DATE_POLICE_NOTIFIED is uniformly distributed | Uniform |
df_index has unique values | Unique |
Unnamed: 0 has unique values | Unique |
CRASH_RECORD_ID has unique values | Unique |
RD_NO has unique values | Unique |
POSTED_SPEED_LIMIT has 6421 (1.6%) zeros | Zeros |
LANE_CNT has 7792 (2.0%) zeros | Zeros |
INJURIES_TOTAL has 349923 (87.9%) zeros | Zeros |
INJURIES_INCAPACITATING has 392141 (98.5%) zeros | Zeros |
INJURIES_NON_INCAPACITATING has 370685 (93.1%) zeros | Zeros |
INJURIES_REPORTED_NOT_EVIDENT has 381101 (95.7%) zeros | Zeros |
INJURIES_NO_INDICATION has 6716 (1.7%) zeros | Zeros |
CRASH_HOUR has 7544 (1.9%) zeros | Zeros |
| Distinct count | 398194 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 211161.53800911113 |
|---|---|
| Minimum | 2 |
| Maximum | 416197 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 26830.65 |
| Q1 | 108821.25 |
| median | 211325.5 |
| Q3 | 313776.75 |
| 95-th percentile | 395693.35 |
| Maximum | 416197 |
| Range | 416195 |
| Interquartile range (IQR) | 204955.5 |
Descriptive statistics
| Standard deviation | 118551.0808 |
|---|---|
| Coefficient of variation (CV) | 0.561423647 |
| Kurtosis | -1.191530902 |
| Mean | 211161.538 |
| Median Absolute Deviation (MAD) | 102477.5 |
| Skewness | -0.006951055101 |
| Sum | 8.408325747e+10 |
| Variance | 1.405435875e+10 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 166660 | 1 | < 0.1% | |
| 383726 | 1 | < 0.1% | |
| 381679 | 1 | < 0.1% | |
| 338672 | 1 | < 0.1% | |
| 336625 | 1 | < 0.1% | |
| 342770 | 1 | < 0.1% | |
| 340723 | 1 | < 0.1% | |
| 330484 | 1 | < 0.1% | |
| 328437 | 1 | < 0.1% | |
| Other values (398184) | 398184 | > 99.9% |
| Value | Count | Frequency (%) | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 416197 | 1 | < 0.1% | |
| 416196 | 1 | < 0.1% | |
| 416195 | 1 | < 0.1% | |
| 416194 | 1 | < 0.1% | |
| 416193 | 1 | < 0.1% |
| Distinct count | 398194 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 211161.53800911113 |
|---|---|
| Minimum | 2 |
| Maximum | 416197 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 26830.65 |
| Q1 | 108821.25 |
| median | 211325.5 |
| Q3 | 313776.75 |
| 95-th percentile | 395693.35 |
| Maximum | 416197 |
| Range | 416195 |
| Interquartile range (IQR) | 204955.5 |
Descriptive statistics
| Standard deviation | 118551.0808 |
|---|---|
| Coefficient of variation (CV) | 0.561423647 |
| Kurtosis | -1.191530902 |
| Mean | 211161.538 |
| Median Absolute Deviation (MAD) | 102477.5 |
| Skewness | -0.006951055101 |
| Sum | 8.408325747e+10 |
| Variance | 1.405435875e+10 |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 166660 | 1 | < 0.1% | |
| 383726 | 1 | < 0.1% | |
| 381679 | 1 | < 0.1% | |
| 338672 | 1 | < 0.1% | |
| 336625 | 1 | < 0.1% | |
| 342770 | 1 | < 0.1% | |
| 340723 | 1 | < 0.1% | |
| 330484 | 1 | < 0.1% | |
| 328437 | 1 | < 0.1% | |
| Other values (398184) | 398184 | > 99.9% |
| Value | Count | Frequency (%) | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 416197 | 1 | < 0.1% | |
| 416196 | 1 | < 0.1% | |
| 416195 | 1 | < 0.1% | |
| 416194 | 1 | < 0.1% | |
| 416193 | 1 | < 0.1% |
| Distinct count | 398194 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| 47d4d22e0339b1bf3284cfdcf9d5ec325d09eba37ccc7b93f70f003cbe806cb4538f88fe9b155cb7d018836c6831df2b3cbddb1de5fc3c1aeb2d057a8c15dcae | 1 |
|---|---|
| 5415b00039c962b65cd6c6c84c78e5ded5b437281a1a0c95c67391caa2d1c39559c1391d0a56817e3f7a9ec8b7f4c8464fd4e89695c6065d3a4289f36c660e84 | 1 |
| a72c2f85364749780f67f8d1bc65c03e0867fa4721ffd2e4ccb9fc18708ec8753104dd50db5698e058735c01b86031eb7f48add11f17bb16ca526fe9d6a8e3af | 1 |
| 6fe8ce9f41f01f78e653c434da2ff348b215bf78d995ecdd2d023aed86f1bdca339b0ef816ba36b9410ab9ecfa1f16eb9810e63ca5066b44c55adb7b8f8984e5 | 1 |
| 0bce0eff69612c8815fd62a76aebc08a778156f69586f69a9f88bbafeee149d2c7da268e354baa6ff56697a107bbebe05d72ec3a76841b01ae7ac6401152877a | 1 |
| Other values (398189) |
| Value | Count | Frequency (%) | |
| 47d4d22e0339b1bf3284cfdcf9d5ec325d09eba37ccc7b93f70f003cbe806cb4538f88fe9b155cb7d018836c6831df2b3cbddb1de5fc3c1aeb2d057a8c15dcae | 1 | < 0.1% | |
| 5415b00039c962b65cd6c6c84c78e5ded5b437281a1a0c95c67391caa2d1c39559c1391d0a56817e3f7a9ec8b7f4c8464fd4e89695c6065d3a4289f36c660e84 | 1 | < 0.1% | |
| a72c2f85364749780f67f8d1bc65c03e0867fa4721ffd2e4ccb9fc18708ec8753104dd50db5698e058735c01b86031eb7f48add11f17bb16ca526fe9d6a8e3af | 1 | < 0.1% | |
| 6fe8ce9f41f01f78e653c434da2ff348b215bf78d995ecdd2d023aed86f1bdca339b0ef816ba36b9410ab9ecfa1f16eb9810e63ca5066b44c55adb7b8f8984e5 | 1 | < 0.1% | |
| 0bce0eff69612c8815fd62a76aebc08a778156f69586f69a9f88bbafeee149d2c7da268e354baa6ff56697a107bbebe05d72ec3a76841b01ae7ac6401152877a | 1 | < 0.1% | |
| 90e159d4d3ed879197cd1fa9a15a972f667bdd7ff2563d68aa2c661ab34035762e9bea6e0cec7573ad2e4936a2eb4f6ffc93b9a45f1b655005a120d1e9a791b6 | 1 | < 0.1% | |
| 7e2a202f2db2739a4a8d07ce6979fb3e47ad765552f373728f4d9dc51becd7668fd335fd7c0d5df4e9df7333ee4cb4ea182ece8f54c26d1f39227cac405f9ae0 | 1 | < 0.1% | |
| c27b3981b5bdc1c770d8a360262bcbab413348c22265d5635e671b18e5ac391209d25da4aeb4acbbd4029e75ac02316a625d17a3b800dd1c099dc568d5b6040b | 1 | < 0.1% | |
| 145fd400a0a21f00b6db169626aaef39dff5a0b095846b68ce4170c89e0d4a7d7959270f6f137341b10365bbc145f5d9087d9d8c2a8bfe0d09c1ec228745d64e | 1 | < 0.1% | |
| 340070be8386feac0c79b6ba4ae13ef2c11caaa1770857254bda4656e3553089ca5462f922838147cbe4d1c57a503230e52637948f9823c2b38d0a28644b0833 | 1 | < 0.1% | |
| Other values (398184) | 398184 | > 99.9% |
Length
| Max length | 128 |
|---|---|
| Median length | 128 |
| Mean length | 128 |
| Min length | 128 |
| Distinct count | 398194 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| JB125535 | 1 |
|---|---|
| JA569371 | 1 |
| JD164013 | 1 |
| JA333494 | 1 |
| JD148417 | 1 |
| Other values (398189) |
| Value | Count | Frequency (%) | |
| JB125535 | 1 | < 0.1% | |
| JA569371 | 1 | < 0.1% | |
| JD164013 | 1 | < 0.1% | |
| JA333494 | 1 | < 0.1% | |
| JD148417 | 1 | < 0.1% | |
| JC147248 | 1 | < 0.1% | |
| JB312556 | 1 | < 0.1% | |
| JD139137 | 1 | < 0.1% | |
| JA238695 | 1 | < 0.1% | |
| JC422545 | 1 | < 0.1% | |
| Other values (398184) | 398184 | > 99.9% |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
| Distinct count | 259780 |
|---|---|
| Unique (%) | 65.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| 11/10/2017 10:30:00 AM | 26 |
|---|---|
| 11/10/2017 10:00:00 AM | 20 |
| 01/12/2019 02:30:00 PM | 18 |
| 01/12/2019 03:00:00 PM | 18 |
| 01/12/2019 02:00:00 PM | 17 |
| Other values (259775) |
| Value | Count | Frequency (%) | |
| 11/10/2017 10:30:00 AM | 26 | < 0.1% | |
| 11/10/2017 10:00:00 AM | 20 | < 0.1% | |
| 01/12/2019 02:30:00 PM | 18 | < 0.1% | |
| 01/12/2019 03:00:00 PM | 18 | < 0.1% | |
| 01/12/2019 02:00:00 PM | 17 | < 0.1% | |
| 09/04/2018 08:00:00 AM | 16 | < 0.1% | |
| 02/26/2020 08:00:00 AM | 15 | < 0.1% | |
| 01/12/2019 04:00:00 PM | 15 | < 0.1% | |
| 02/26/2020 07:45:00 AM | 15 | < 0.1% | |
| 02/10/2019 02:00:00 PM | 15 | < 0.1% | |
| Other values (259770) | 398019 | > 99.9% |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.260358016444247 |
|---|---|
| Minimum | 0.0 |
| Maximum | 70.0 |
| Zeros | 6421 |
| Zeros (%) | 1.6% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 30 |
| median | 30 |
| Q3 | 30 |
| 95-th percentile | 35 |
| Maximum | 70 |
| Range | 70 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 6.49276033 |
|---|---|
| Coefficient of variation (CV) | 0.2297479857 |
| Kurtosis | 6.834174355 |
| Mean | 28.26035802 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.217937382 |
| Sum | 11253105 |
| Variance | 42.1559367 |
| Value | Count | Frequency (%) | |
| 30 | 294635 | 74.0% | |
| 35 | 27095 | 6.8% | |
| 25 | 23822 | 6.0% | |
| 20 | 15082 | 3.8% | |
| 15 | 13568 | 3.4% | |
| 10 | 8026 | 2.0% | |
| 0 | 6421 | 1.6% | |
| 40 | 3584 | 0.9% | |
| 5 | 3270 | 0.8% | |
| 45 | 2281 | 0.6% | |
| Other values (5) | 410 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 6421 | 1.6% | |
| 5 | 3270 | 0.8% | |
| 10 | 8026 | 2.0% | |
| 15 | 13568 | 3.4% | |
| 20 | 15082 | 3.8% |
| Value | Count | Frequency (%) | |
| 70 | 3 | < 0.1% | |
| 65 | 6 | < 0.1% | |
| 60 | 23 | < 0.1% | |
| 55 | 305 | 0.1% | |
| 50 | 73 | < 0.1% |
TRAFFIC_CONTROL_DEVICE
Categorical
| Distinct count | 19 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| NO CONTROLS | |
|---|---|
| TRAFFIC SIGNAL | |
| STOP SIGN/FLASHER | 39132 |
| UNKNOWN | 12848 |
| OTHER | 2319 |
| Other values (14) | 3478 |
| Value | Count | Frequency (%) | |
| NO CONTROLS | 229331 | 57.6% | |
| TRAFFIC SIGNAL | 111086 | 27.9% | |
| STOP SIGN/FLASHER | 39132 | 9.8% | |
| UNKNOWN | 12848 | 3.2% | |
| OTHER | 2319 | 0.6% | |
| LANE USE MARKING | 1141 | 0.3% | |
| YIELD | 551 | 0.1% | |
| OTHER REG. SIGN | 375 | 0.1% | |
| OTHER WARNING SIGN | 353 | 0.1% | |
| RAILROAD CROSSING GATE | 276 | 0.1% | |
| Other values (9) | 782 | 0.2% |
Length
| Max length | 24 |
|---|---|
| Median length | 11 |
| Mean length | 12.29784226 |
| Min length | 5 |
DEVICE_CONDITION
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| NO CONTROLS | |
|---|---|
| FUNCTIONING PROPERLY | |
| UNKNOWN | 21575 |
| OTHER | 3030 |
| FUNCTIONING IMPROPERLY | 2230 |
| Other values (3) | 1532 |
| Value | Count | Frequency (%) | |
| NO CONTROLS | 231548 | 58.1% | |
| FUNCTIONING PROPERLY | 138279 | 34.7% | |
| UNKNOWN | 21575 | 5.4% | |
| OTHER | 3030 | 0.8% | |
| FUNCTIONING IMPROPERLY | 2230 | 0.6% | |
| NOT FUNCTIONING | 1292 | 0.3% | |
| WORN REFLECTIVE MATERIAL | 188 | < 0.1% | |
| MISSING | 52 | < 0.1% |
Length
| Max length | 24 |
|---|---|
| Median length | 11 |
| Mean length | 13.94320105 |
| Min length | 5 |
WEATHER_CONDITION
Categorical
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| CLEAR | |
|---|---|
| RAIN | 36485 |
| UNKNOWN | 17212 |
| SNOW | 15074 |
| CLOUDY/OVERCAST | 12242 |
| Other values (7) | 3151 |
| Value | Count | Frequency (%) | |
| CLEAR | 314030 | 78.9% | |
| RAIN | 36485 | 9.2% | |
| UNKNOWN | 17212 | 4.3% | |
| SNOW | 15074 | 3.8% | |
| CLOUDY/OVERCAST | 12242 | 3.1% | |
| OTHER | 1271 | 0.3% | |
| FOG/SMOKE/HAZE | 756 | 0.2% | |
| SLEET/HAIL | 626 | 0.2% | |
| FREEZING RAIN/DRIZZLE | 360 | 0.1% | |
| SEVERE CROSS WIND GATE | 78 | < 0.1% | |
| Other values (2) | 60 | < 0.1% |
Length
| Max length | 24 |
|---|---|
| Median length | 5 |
| Mean length | 5.308234177 |
| Min length | 4 |
LIGHTING_CONDITION
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| DAYLIGHT | |
|---|---|
| DARKNESS, LIGHTED ROAD | |
| DARKNESS | 20209 |
| UNKNOWN | 14392 |
| DUSK | 12206 |
| Value | Count | Frequency (%) | |
| DAYLIGHT | 261434 | 65.7% | |
| DARKNESS, LIGHTED ROAD | 83035 | 20.9% | |
| DARKNESS | 20209 | 5.1% | |
| UNKNOWN | 14392 | 3.6% | |
| DUSK | 12206 | 3.1% | |
| DAWN | 6918 | 1.7% |
Length
| Max length | 22 |
|---|---|
| Median length | 8 |
| Mean length | 10.69115557 |
| Min length | 4 |
FIRST_CRASH_TYPE
Categorical
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| REAR END | |
|---|---|
| PARKED MOTOR VEHICLE | |
| SIDESWIPE SAME DIRECTION | |
| TURNING | |
| ANGLE | |
| Other values (13) |
| Value | Count | Frequency (%) | |
| REAR END | 97874 | 24.6% | |
| PARKED MOTOR VEHICLE | 89406 | 22.5% | |
| SIDESWIPE SAME DIRECTION | 63545 | 16.0% | |
| TURNING | 55538 | 13.9% | |
| ANGLE | 41640 | 10.5% | |
| FIXED OBJECT | 17397 | 4.4% | |
| PEDESTRIAN | 9338 | 2.3% | |
| SIDESWIPE OPPOSITE DIRECTION | 5878 | 1.5% | |
| PEDALCYCLIST | 5701 | 1.4% | |
| OTHER OBJECT | 3621 | 0.9% | |
| Other values (8) | 8256 | 2.1% |
Length
| Max length | 28 |
|---|---|
| Median length | 10 |
| Mean length | 13.46595629 |
| Min length | 5 |
TRAFFICWAY_TYPE
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| NOT DIVIDED | |
|---|---|
| DIVIDED - W/MEDIAN (NOT RAISED) | |
| ONE-WAY | |
| PARKING LOT | 28698 |
| DIVIDED - W/MEDIAN BARRIER | 23959 |
| Other values (15) |
| Value | Count | Frequency (%) | |
| NOT DIVIDED | 180096 | 45.2% | |
| DIVIDED - W/MEDIAN (NOT RAISED) | 72633 | 18.2% | |
| ONE-WAY | 52598 | 13.2% | |
| PARKING LOT | 28698 | 7.2% | |
| DIVIDED - W/MEDIAN BARRIER | 23959 | 6.0% | |
| OTHER | 11428 | 2.9% | |
| FOUR WAY | 8657 | 2.2% | |
| ALLEY | 6417 | 1.6% | |
| UNKNOWN | 4321 | 1.1% | |
| CENTER TURN LANE | 3529 | 0.9% | |
| Other values (10) | 5858 | 1.5% |
Length
| Max length | 31 |
|---|---|
| Median length | 11 |
| Mean length | 14.69813207 |
| Min length | 4 |
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 205498 |
| Missing (%) | 51.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.681062398804334 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1191625.0 |
| Zeros | 7792 |
| Zeros (%) | 2.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 1191625 |
| Range | 1191625 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3009.722933 |
|---|---|
| Coefficient of variation (CV) | 219.9919016 |
| Kurtosis | 130406.2615 |
| Mean | 13.6810624 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 344.7025902 |
| Sum | 2636286 |
| Variance | 9058432.131 |
| Value | Count | Frequency (%) | |
| 2 | 88259 | 22.2% | |
| 4 | 48092 | 12.1% | |
| 1 | 31620 | 7.9% | |
| 3 | 8262 | 2.1% | |
| 0 | 7792 | 2.0% | |
| 6 | 4324 | 1.1% | |
| 5 | 1881 | 0.5% | |
| 8 | 1851 | 0.5% | |
| 7 | 179 | < 0.1% | |
| 10 | 151 | < 0.1% | |
| Other values (30) | 285 | 0.1% | |
| (Missing) | 205498 | 51.6% |
| Value | Count | Frequency (%) | |
| 0 | 7792 | 2.0% | |
| 1 | 31620 | 7.9% | |
| 2 | 88259 | 22.2% | |
| 3 | 8262 | 2.1% | |
| 4 | 48092 | 12.1% |
| Value | Count | Frequency (%) | |
| 1191625 | 1 | < 0.1% | |
| 433634 | 1 | < 0.1% | |
| 299679 | 1 | < 0.1% | |
| 218474 | 1 | < 0.1% | |
| 902 | 1 | < 0.1% |
ALIGNMENT
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| STRAIGHT AND LEVEL | |
|---|---|
| STRAIGHT ON GRADE | 4801 |
| CURVE, LEVEL | 2915 |
| STRAIGHT ON HILLCREST | 1265 |
| CURVE ON GRADE | 554 |
| Value | Count | Frequency (%) | |
| STRAIGHT AND LEVEL | 388465 | 97.6% | |
| STRAIGHT ON GRADE | 4801 | 1.2% | |
| CURVE, LEVEL | 2915 | 0.7% | |
| STRAIGHT ON HILLCREST | 1265 | 0.3% | |
| CURVE ON GRADE | 554 | 0.1% | |
| CURVE ON HILLCREST | 194 | < 0.1% |
Length
| Max length | 21 |
|---|---|
| Median length | 18 |
| Mean length | 17.94798515 |
| Min length | 12 |
ROADWAY_SURFACE_COND
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| DRY | |
|---|---|
| WET | 56060 |
| UNKNOWN | 26201 |
| SNOW OR SLUSH | 14378 |
| ICE | 3288 |
| Other values (2) | 1120 |
| Value | Count | Frequency (%) | |
| DRY | 297147 | 74.6% | |
| WET | 56060 | 14.1% | |
| UNKNOWN | 26201 | 6.6% | |
| SNOW OR SLUSH | 14378 | 3.6% | |
| ICE | 3288 | 0.8% | |
| OTHER | 927 | 0.2% | |
| SAND, MUD, DIRT | 193 | < 0.1% |
Length
| Max length | 15 |
|---|---|
| Median length | 3 |
| Mean length | 3.6347509 |
| Min length | 3 |
ROAD_DEFECT
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| NO DEFECTS | |
|---|---|
| UNKNOWN | 57079 |
| RUT, HOLES | 4085 |
| OTHER | 2304 |
| WORN SURFACE | 1664 |
| Other values (2) | 1221 |
| Value | Count | Frequency (%) | |
| NO DEFECTS | 331841 | 83.3% | |
| UNKNOWN | 57079 | 14.3% | |
| RUT, HOLES | 4085 | 1.0% | |
| OTHER | 2304 | 0.6% | |
| WORN SURFACE | 1664 | 0.4% | |
| SHOULDER DEFECT | 866 | 0.2% | |
| DEBRIS ON ROADWAY | 355 | 0.1% |
Length
| Max length | 17 |
|---|---|
| Median length | 10 |
| Mean length | 9.566507783 |
| Min length | 5 |
REPORT_TYPE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| NOT ON SCENE (DESK REPORT) | |
|---|---|
| ON SCENE |
| Value | Count | Frequency (%) | |
| NOT ON SCENE (DESK REPORT) | 243549 | 61.2% | |
| ON SCENE | 154645 | 38.8% |
Length
| Max length | 26 |
|---|---|
| Median length | 26 |
| Mean length | 19.0094125 |
| Min length | 8 |
CRASH_TYPE
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| NO INJURY / DRIVE AWAY | |
|---|---|
| INJURY AND / OR TOW DUE TO CRASH |
| Value | Count | Frequency (%) | |
| NO INJURY / DRIVE AWAY | 306031 | 76.9% | |
| INJURY AND / OR TOW DUE TO CRASH | 92163 | 23.1% |
Length
| Max length | 32 |
|---|---|
| Median length | 22 |
| Mean length | 24.31452508 |
| Min length | 22 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 309667 |
| Missing (%) | 77.8% |
| Memory size | 3.0 MiB |
| Y | |
|---|---|
| N | 4207 |
| (Missing) |
| Value | Count | Frequency (%) | |
| Y | 84320 | 21.2% | |
| N | 4207 | 1.1% | |
| (Missing) | 309667 | 77.8% |
HIT_AND_RUN_I
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 290995 | 73.1% | |
| 1 | 107199 | 26.9% |
DAMAGE
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| OVER $1,500 | |
|---|---|
| $501 - $1,500 | |
| $500 OR LESS |
| Value | Count | Frequency (%) | |
| OVER $1,500 | 225505 | 56.6% | |
| $501 - $1,500 | 119715 | 30.1% | |
| $500 OR LESS | 52974 | 13.3% |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 11.73432548 |
| Min length | 11 |
| Distinct count | 307208 |
|---|---|
| Unique (%) | 77.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| 02/26/2020 08:30:00 AM | 12 |
|---|---|
| 06/30/2018 09:30:00 PM | 11 |
| 02/14/2020 05:00:00 PM | 11 |
| 05/25/2018 06:00:00 PM | 10 |
| 06/03/2019 06:00:00 PM | 10 |
| Other values (307203) |
| Value | Count | Frequency (%) | |
| 02/26/2020 08:30:00 AM | 12 | < 0.1% | |
| 06/30/2018 09:30:00 PM | 11 | < 0.1% | |
| 02/14/2020 05:00:00 PM | 11 | < 0.1% | |
| 05/25/2018 06:00:00 PM | 10 | < 0.1% | |
| 06/03/2019 06:00:00 PM | 10 | < 0.1% | |
| 10/25/2017 04:30:00 PM | 10 | < 0.1% | |
| 05/31/2019 04:00:00 PM | 10 | < 0.1% | |
| 05/01/2018 05:00:00 PM | 10 | < 0.1% | |
| 09/13/2019 05:00:00 PM | 10 | < 0.1% | |
| 02/05/2020 05:00:00 PM | 10 | < 0.1% | |
| Other values (307198) | 398090 | > 99.9% |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
PRIM_CONTRIBUTORY_CAUSE
Categorical
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| UNABLE TO DETERMINE | |
|---|---|
| FAILING TO YIELD RIGHT-OF-WAY | |
| FOLLOWING TOO CLOSELY | |
| NOT APPLICABLE | 21300 |
| IMPROPER OVERTAKING/PASSING | 19222 |
| Other values (35) |
| Value | Count | Frequency (%) | |
| UNABLE TO DETERMINE | 144644 | 36.3% | |
| FAILING TO YIELD RIGHT-OF-WAY | 44560 | 11.2% | |
| FOLLOWING TOO CLOSELY | 44122 | 11.1% | |
| NOT APPLICABLE | 21300 | 5.3% | |
| IMPROPER OVERTAKING/PASSING | 19222 | 4.8% | |
| IMPROPER BACKING | 18045 | 4.5% | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 16802 | 4.2% | |
| IMPROPER LANE USAGE | 15944 | 4.0% | |
| IMPROPER TURNING/NO SIGNAL | 13457 | 3.4% | |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 12448 | 3.1% | |
| Other values (30) | 47650 | 12.0% |
Length
| Max length | 80 |
|---|---|
| Median length | 19 |
| Mean length | 23.708195 |
| Min length | 6 |
SEC_CONTRIBUTORY_CAUSE
Categorical
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| NOT APPLICABLE | |
|---|---|
| UNABLE TO DETERMINE | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 16766 |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 12714 |
| FAILING TO YIELD RIGHT-OF-WAY | 12298 |
| Other values (35) |
| Value | Count | Frequency (%) | |
| NOT APPLICABLE | 159708 | 40.1% | |
| UNABLE TO DETERMINE | 141731 | 35.6% | |
| FAILING TO REDUCE SPEED TO AVOID CRASH | 16766 | 4.2% | |
| DRIVING SKILLS/KNOWLEDGE/EXPERIENCE | 12714 | 3.2% | |
| FAILING TO YIELD RIGHT-OF-WAY | 12298 | 3.1% | |
| FOLLOWING TOO CLOSELY | 11387 | 2.9% | |
| IMPROPER OVERTAKING/PASSING | 5980 | 1.5% | |
| IMPROPER LANE USAGE | 5921 | 1.5% | |
| WEATHER | 5104 | 1.3% | |
| IMPROPER TURNING/NO SIGNAL | 4017 | 1.0% | |
| Other values (30) | 22568 | 5.7% |
Length
| Max length | 80 |
|---|---|
| Median length | 19 |
| Mean length | 19.71373752 |
| Min length | 6 |
STREET_NO
Real number (ℝ≥0)
| Distinct count | 10786 |
|---|---|
| Unique (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3598.388516652687 |
|---|---|
| Minimum | 1 |
| Maximum | 13799 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 138 |
| Q1 | 1200 |
| median | 3119 |
| Q3 | 5501 |
| 95-th percentile | 8723 |
| Maximum | 13799 |
| Range | 13798 |
| Interquartile range (IQR) | 4301 |
Descriptive statistics
| Standard deviation | 2815.384209 |
|---|---|
| Coefficient of variation (CV) | 0.7824013988 |
| Kurtosis | 0.02470885059 |
| Mean | 3598.388517 |
| Median Absolute Deviation (MAD) | 2114 |
| Skewness | 0.7645571692 |
| Sum | 1432856717 |
| Variance | 7926388.243 |
| Value | Count | Frequency (%) | |
| 100 | 2702 | 0.7% | |
| 1600 | 2517 | 0.6% | |
| 200 | 2422 | 0.6% | |
| 800 | 2403 | 0.6% | |
| 300 | 2263 | 0.6% | |
| 500 | 2137 | 0.5% | |
| 6300 | 2028 | 0.5% | |
| 600 | 2006 | 0.5% | |
| 1200 | 1981 | 0.5% | |
| 4700 | 1963 | 0.5% | |
| Other values (10776) | 375772 | 94.4% |
| Value | Count | Frequency (%) | |
| 1 | 1481 | 0.4% | |
| 2 | 775 | 0.2% | |
| 3 | 122 | < 0.1% | |
| 4 | 79 | < 0.1% | |
| 5 | 196 | < 0.1% |
| Value | Count | Frequency (%) | |
| 13799 | 3 | < 0.1% | |
| 13780 | 1 | < 0.1% | |
| 13770 | 13 | < 0.1% | |
| 13762 | 1 | < 0.1% | |
| 13758 | 1 | < 0.1% |
STREET_DIRECTION
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| W | |
|---|---|
| S | |
| N | |
| E | 27464 |
| Value | Count | Frequency (%) | |
| W | 142252 | 35.7% | |
| S | 129803 | 32.6% | |
| N | 98675 | 24.8% | |
| E | 27464 | 6.9% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 1500 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| WESTERN AVE | 10979 |
|---|---|
| PULASKI RD | 9489 |
| CICERO AVE | 8694 |
| ASHLAND AVE | 8620 |
| HALSTED ST | 7570 |
| Other values (1495) |
| Value | Count | Frequency (%) | |
| WESTERN AVE | 10979 | 2.8% | |
| PULASKI RD | 9489 | 2.4% | |
| CICERO AVE | 8694 | 2.2% | |
| ASHLAND AVE | 8620 | 2.2% | |
| HALSTED ST | 7570 | 1.9% | |
| KEDZIE AVE | 6723 | 1.7% | |
| MICHIGAN AVE | 5572 | 1.4% | |
| STATE ST | 4911 | 1.2% | |
| CLARK ST | 4771 | 1.2% | |
| NORTH AVE | 4758 | 1.2% | |
| Other values (1490) | 326107 | 81.9% |
Length
| Max length | 27 |
|---|---|
| Median length | 10 |
| Mean length | 10.67221254 |
| Min length | 5 |
BEAT_OF_OCCURRENCE
Real number (ℝ≥0)
| Distinct count | 271 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1248.675286418178 |
|---|---|
| Minimum | 111.0 |
| Maximum | 2535.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 111 |
|---|---|
| 5-th percentile | 124 |
| Q1 | 715 |
| median | 1214 |
| Q3 | 1824 |
| 95-th percentile | 2512 |
| Maximum | 2535 |
| Range | 2424 |
| Interquartile range (IQR) | 1109 |
Descriptive statistics
| Standard deviation | 709.6164418 |
|---|---|
| Coefficient of variation (CV) | 0.5682954164 |
| Kurtosis | -1.023902108 |
| Mean | 1248.675286 |
| Median Absolute Deviation (MAD) | 590 |
| Skewness | 0.1351788021 |
| Sum | 497215007 |
| Variance | 503555.4945 |
| Value | Count | Frequency (%) | |
| 1834 | 5643 | 1.4% | |
| 122 | 4567 | 1.1% | |
| 114 | 4532 | 1.1% | |
| 1831 | 4522 | 1.1% | |
| 813 | 4026 | 1.0% | |
| 815 | 3775 | 0.9% | |
| 833 | 3228 | 0.8% | |
| 2413 | 3107 | 0.8% | |
| 1232 | 3054 | 0.8% | |
| 834 | 2961 | 0.7% | |
| Other values (261) | 358779 | 90.1% |
| Value | Count | Frequency (%) | |
| 111 | 2144 | 0.5% | |
| 112 | 1580 | 0.4% | |
| 113 | 1091 | 0.3% | |
| 114 | 4532 | 1.1% | |
| 121 | 2382 | 0.6% |
| Value | Count | Frequency (%) | |
| 2535 | 1233 | 0.3% | |
| 2534 | 1633 | 0.4% | |
| 2533 | 2602 | 0.7% | |
| 2532 | 1043 | 0.3% | |
| 2531 | 1071 | 0.3% |
NUM_UNITS
Real number (ℝ≥0)
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0218084652204706 |
|---|---|
| Minimum | 1.0 |
| Maximum | 18.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 18 |
| Range | 17 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4139876489 |
|---|---|
| Coefficient of variation (CV) | 0.2047610622 |
| Kurtosis | 37.17641388 |
| Mean | 2.021808465 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.077377139 |
| Sum | 805072 |
| Variance | 0.1713857735 |
| Value | Count | Frequency (%) | |
| 2 | 353452 | 88.8% | |
| 1 | 21066 | 5.3% | |
| 3 | 19267 | 4.8% | |
| 4 | 3315 | 0.8% | |
| 5 | 760 | 0.2% | |
| 6 | 206 | 0.1% | |
| 7 | 78 | < 0.1% | |
| 8 | 25 | < 0.1% | |
| 9 | 11 | < 0.1% | |
| 10 | 7 | < 0.1% | |
| Other values (4) | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 21066 | 5.3% | |
| 2 | 353452 | 88.8% | |
| 3 | 19267 | 4.8% | |
| 4 | 3315 | 0.8% | |
| 5 | 760 | 0.2% |
| Value | Count | Frequency (%) | |
| 18 | 1 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 12 | 2 | < 0.1% | |
| 11 | 3 | < 0.1% | |
| 10 | 7 | < 0.1% |
MOST_SEVERE_INJURY
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| NO INDICATION OF INJURY | |
|---|---|
| NONINCAPACITATING INJURY | 26484 |
| REPORTED, NOT EVIDENT | 15490 |
| INCAPACITATING INJURY | 6013 |
| FATAL | 284 |
| Value | Count | Frequency (%) | |
| NO INDICATION OF INJURY | 349923 | 87.9% | |
| NONINCAPACITATING INJURY | 26484 | 6.7% | |
| REPORTED, NOT EVIDENT | 15490 | 3.9% | |
| INCAPACITATING INJURY | 6013 | 1.5% | |
| FATAL | 284 | 0.1% |
Length
| Max length | 24 |
|---|---|
| Median length | 23 |
| Mean length | 22.9456697 |
| Min length | 5 |
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.16355595513744556 |
|---|---|
| Minimum | 0.0 |
| Maximum | 21.0 |
| Zeros | 349923 |
| Zeros (%) | 87.9% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5221584262 |
|---|---|
| Coefficient of variation (CV) | 3.192536926 |
| Kurtosis | 56.07949933 |
| Mean | 0.1635559551 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.26015217 |
| Sum | 65127 |
| Variance | 0.272649422 |
| Value | Count | Frequency (%) | |
| 0 | 349923 | 87.9% | |
| 1 | 37184 | 9.3% | |
| 2 | 7552 | 1.9% | |
| 3 | 2242 | 0.6% | |
| 4 | 796 | 0.2% | |
| 5 | 296 | 0.1% | |
| 6 | 110 | < 0.1% | |
| 7 | 44 | < 0.1% | |
| 8 | 14 | < 0.1% | |
| 9 | 14 | < 0.1% | |
| Other values (7) | 19 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 349923 | 87.9% | |
| 1 | 37184 | 9.3% | |
| 2 | 7552 | 1.9% | |
| 3 | 2242 | 0.6% | |
| 4 | 796 | 0.2% |
| Value | Count | Frequency (%) | |
| 21 | 2 | < 0.1% | |
| 19 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 13 | 2 | < 0.1% |
INJURIES_FATAL
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| 0 | |
|---|---|
| 1 | 265 |
| 2 | 15 |
| 3 | 4 |
| Value | Count | Frequency (%) | |
| 0 | 397910 | 99.9% | |
| 1 | 265 | 0.1% | |
| 2 | 15 | < 0.1% | |
| 3 | 4 | < 0.1% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.01762708629462021 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7.0 |
| Zeros | 392141 |
| Zeros (%) | 98.5% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.1546000071 |
|---|---|
| Coefficient of variation (CV) | 8.770593423 |
| Kurtosis | 190.3613331 |
| Mean | 0.01762708629 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.63650857 |
| Sum | 7019 |
| Variance | 0.0239011622 |
| Value | Count | Frequency (%) | |
| 0 | 392141 | 98.5% | |
| 1 | 5343 | 1.3% | |
| 2 | 525 | 0.1% | |
| 3 | 128 | < 0.1% | |
| 4 | 46 | < 0.1% | |
| 5 | 9 | < 0.1% | |
| 7 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 392141 | 98.5% | |
| 1 | 5343 | 1.3% | |
| 2 | 525 | 0.1% | |
| 3 | 128 | < 0.1% | |
| 4 | 46 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7 | 1 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 5 | 9 | < 0.1% | |
| 4 | 46 | < 0.1% | |
| 3 | 128 | < 0.1% |
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0896146099639874 |
|---|---|
| Minimum | 0.0 |
| Maximum | 21.0 |
| Zeros | 370685 |
| Zeros (%) | 93.1% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.3846934118 |
|---|---|
| Coefficient of variation (CV) | 4.29275329 |
| Kurtosis | 126.8850279 |
| Mean | 0.08961460996 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.454393917 |
| Sum | 35684 |
| Variance | 0.147989021 |
| Value | Count | Frequency (%) | |
| 0 | 370685 | 93.1% | |
| 1 | 22093 | 5.5% | |
| 2 | 3713 | 0.9% | |
| 3 | 1096 | 0.3% | |
| 4 | 384 | 0.1% | |
| 5 | 130 | < 0.1% | |
| 6 | 53 | < 0.1% | |
| 7 | 19 | < 0.1% | |
| 10 | 5 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| Other values (6) | 11 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 370685 | 93.1% | |
| 1 | 22093 | 5.5% | |
| 2 | 3713 | 0.9% | |
| 3 | 1096 | 0.3% | |
| 4 | 384 | 0.1% |
| Value | Count | Frequency (%) | |
| 21 | 2 | < 0.1% | |
| 18 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 11 | 3 | < 0.1% |
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.055543277899717226 |
|---|---|
| Minimum | 0.0 |
| Maximum | 10.0 |
| Zeros | 381101 |
| Zeros (%) | 95.7% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2996112402 |
|---|---|
| Coefficient of variation (CV) | 5.394194429 |
| Kurtosis | 96.3037381 |
| Mean | 0.0555432779 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.909177094 |
| Sum | 22117 |
| Variance | 0.08976689526 |
| Value | Count | Frequency (%) | |
| 0 | 381101 | 95.7% | |
| 1 | 13563 | 3.4% | |
| 2 | 2565 | 0.6% | |
| 3 | 645 | 0.2% | |
| 4 | 198 | < 0.1% | |
| 5 | 82 | < 0.1% | |
| 6 | 17 | < 0.1% | |
| 7 | 10 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 9 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 381101 | 95.7% | |
| 1 | 13563 | 3.4% | |
| 2 | 2565 | 0.6% | |
| 3 | 645 | 0.2% | |
| 4 | 198 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10 | 3 | < 0.1% | |
| 9 | 5 | < 0.1% | |
| 8 | 5 | < 0.1% | |
| 7 | 10 | < 0.1% | |
| 6 | 17 | < 0.1% |
| Distinct count | 42 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0195507717343806 |
|---|---|
| Minimum | 0.0 |
| Maximum | 61.0 |
| Zeros | 6716 |
| Zeros (%) | 1.7% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 61 |
| Range | 61 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.15556234 |
|---|---|
| Coefficient of variation (CV) | 0.5721878131 |
| Kurtosis | 91.15031613 |
| Mean | 2.019550772 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.371242876 |
| Sum | 804173 |
| Variance | 1.335324321 |
| Value | Count | Frequency (%) | |
| 2 | 191710 | 48.1% | |
| 1 | 118032 | 29.6% | |
| 3 | 49552 | 12.4% | |
| 4 | 18668 | 4.7% | |
| 5 | 7808 | 2.0% | |
| 0 | 6716 | 1.7% | |
| 6 | 3313 | 0.8% | |
| 7 | 1236 | 0.3% | |
| 8 | 566 | 0.1% | |
| 9 | 236 | 0.1% | |
| Other values (32) | 357 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 6716 | 1.7% | |
| 1 | 118032 | 29.6% | |
| 2 | 191710 | 48.1% | |
| 3 | 49552 | 12.4% | |
| 4 | 18668 | 4.7% |
| Value | Count | Frequency (%) | |
| 61 | 1 | < 0.1% | |
| 50 | 1 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 42 | 3 | < 0.1% | |
| 40 | 2 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 398194 | 100.0% |
| Distinct count | 24 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.192619677845473 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros | 7544 |
| Zeros (%) | 1.9% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 9 |
| median | 14 |
| Q3 | 17 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.45022083 |
|---|---|
| Coefficient of variation (CV) | 0.4131265028 |
| Kurtosis | -0.3903240384 |
| Mean | 13.19261968 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.3950513913 |
| Sum | 5253222 |
| Variance | 29.70490709 |
| Value | Count | Frequency (%) | |
| 16 | 30499 | 7.7% | |
| 15 | 30482 | 7.7% | |
| 17 | 30173 | 7.6% | |
| 14 | 26860 | 6.7% | |
| 18 | 24890 | 6.3% | |
| 13 | 24390 | 6.1% | |
| 12 | 23433 | 5.9% | |
| 8 | 22676 | 5.7% | |
| 11 | 20157 | 5.1% | |
| 9 | 19280 | 4.8% | |
| Other values (14) | 145354 | 36.5% |
| Value | Count | Frequency (%) | |
| 0 | 7544 | 1.9% | |
| 1 | 6375 | 1.6% | |
| 2 | 5688 | 1.4% | |
| 3 | 4673 | 1.2% | |
| 4 | 4354 | 1.1% |
| Value | Count | Frequency (%) | |
| 23 | 9493 | 2.4% | |
| 22 | 11533 | 2.9% | |
| 21 | 12445 | 3.1% | |
| 20 | 13942 | 3.5% | |
| 19 | 17871 | 4.5% |
CRASH_DAY_OF_WEEK
Real number (ℝ≥0)
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.124816044440649 |
|---|---|
| Minimum | 1 |
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.967291944 |
|---|---|
| Coefficient of variation (CV) | 0.4769405284 |
| Kurtosis | -1.228995325 |
| Mean | 4.124816044 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.07200053495 |
| Sum | 1642477 |
| Variance | 3.870237593 |
| Value | Count | Frequency (%) | |
| 6 | 64754 | 16.3% | |
| 7 | 58132 | 14.6% | |
| 3 | 57885 | 14.5% | |
| 5 | 57334 | 14.4% | |
| 4 | 57026 | 14.3% | |
| 2 | 55537 | 13.9% | |
| 1 | 47526 | 11.9% |
| Value | Count | Frequency (%) | |
| 1 | 47526 | 11.9% | |
| 2 | 55537 | 13.9% | |
| 3 | 57885 | 14.5% | |
| 4 | 57026 | 14.3% | |
| 5 | 57334 | 14.4% |
| Value | Count | Frequency (%) | |
| 7 | 58132 | 14.6% | |
| 6 | 64754 | 16.3% | |
| 5 | 57334 | 14.4% | |
| 4 | 57026 | 14.3% | |
| 3 | 57885 | 14.5% |
CRASH_MONTH
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.6087183634108 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.484479819 |
|---|---|
| Coefficient of variation (CV) | 0.5272550028 |
| Kurtosis | -1.239390955 |
| Mean | 6.608718363 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.03985805496 |
| Sum | 2631552 |
| Variance | 12.14159961 |
| Value | Count | Frequency (%) | |
| 10 | 36712 | 9.2% | |
| 12 | 35654 | 9.0% | |
| 5 | 35480 | 8.9% | |
| 11 | 34641 | 8.7% | |
| 9 | 33782 | 8.5% | |
| 1 | 33133 | 8.3% | |
| 6 | 32851 | 8.2% | |
| 3 | 32394 | 8.1% | |
| 2 | 31789 | 8.0% | |
| 8 | 31576 | 7.9% | |
| Other values (2) | 60182 | 15.1% |
| Value | Count | Frequency (%) | |
| 1 | 33133 | 8.3% | |
| 2 | 31789 | 8.0% | |
| 3 | 32394 | 8.1% | |
| 4 | 30262 | 7.6% | |
| 5 | 35480 | 8.9% |
| Value | Count | Frequency (%) | |
| 12 | 35654 | 9.0% | |
| 11 | 34641 | 8.7% | |
| 10 | 36712 | 9.2% | |
| 9 | 33782 | 8.5% | |
| 8 | 31576 | 7.9% |
| Distinct count | 183392 |
|---|---|
| Unique (%) | 46.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.85757696026045 |
|---|---|
| Minimum | 0.0 |
| Maximum | 42.022779861 |
| Zeros | 27 |
| Zeros (%) | < 0.1% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 41.71467264 |
| Q1 | 41.78687426 |
| median | 41.87775187 |
| Q3 | 41.92487836 |
| 95-th percentile | 41.99037309 |
| Maximum | 42.02277986 |
| Range | 42.02277986 |
| Interquartile range (IQR) | 0.1380040987 |
Descriptive statistics
| Standard deviation | 0.3550475061 |
|---|---|
| Coefficient of variation (CV) | 0.008482275656 |
| Kurtosis | 13095.67571 |
| Mean | 41.85757696 |
| Median Absolute Deviation (MAD) | 0.0674057415 |
| Skewness | -111.1077614 |
| Sum | 16667436 |
| Variance | 0.1260587316 |
| Value | Count | Frequency (%) | |
| 41.97620114 | 533 | 0.1% | |
| 41.79142028 | 266 | 0.1% | |
| 41.7514606 | 260 | 0.1% | |
| 41.72225727 | 212 | 0.1% | |
| 41.78932932 | 200 | 0.1% | |
| 41.75466012 | 184 | < 0.1% | |
| 41.90095892 | 170 | < 0.1% | |
| 41.74257762 | 146 | < 0.1% | |
| 41.73638005 | 140 | < 0.1% | |
| 41.79291088 | 138 | < 0.1% | |
| Other values (183382) | 395945 | 99.4% |
| Value | Count | Frequency (%) | |
| 0 | 27 | < 0.1% | |
| 41.64467013 | 11 | < 0.1% | |
| 41.64469152 | 2 | < 0.1% | |
| 41.64469397 | 5 | < 0.1% | |
| 41.64471232 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 42.02277986 | 3 | < 0.1% | |
| 42.02273632 | 1 | < 0.1% | |
| 42.02272017 | 1 | < 0.1% | |
| 42.02266114 | 2 | < 0.1% | |
| 42.02266027 | 2 | < 0.1% |
| Distinct count | 183382 |
|---|---|
| Unique (%) | 46.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -87.67233841457879 |
|---|---|
| Minimum | -87.934014222 |
| Maximum | 0.0 |
| Zeros | 27 |
| Zeros (%) | < 0.1% |
| Memory size | 3.0 MiB |
Quantile statistics
| Minimum | -87.93401422 |
|---|---|
| 5-th percentile | -87.7763876 |
| Q1 | -87.72075637 |
| median | -87.67297088 |
| Q3 | -87.63301193 |
| 95-th percentile | -87.58618584 |
| Maximum | 0 |
| Range | 87.93401422 |
| Interquartile range (IQR) | 0.08774443425 |
Descriptive statistics
| Standard deviation | 0.7243082962 |
|---|---|
| Coefficient of variation (CV) | -0.008261537326 |
| Kurtosis | 14552.70392 |
| Mean | -87.67233841 |
| Median Absolute Deviation (MAD) | 0.04236988 |
| Skewness | 120.2509699 |
| Sum | -34910599.12 |
| Variance | 0.524622508 |
| Value | Count | Frequency (%) | |
| -87.90530913 | 533 | 0.1% | |
| -87.58014777 | 266 | 0.1% | |
| -87.58597199 | 260 | 0.1% | |
| -87.58527557 | 212 | 0.1% | |
| -87.74164564 | 200 | 0.1% | |
| -87.74138476 | 184 | < 0.1% | |
| -87.61992817 | 170 | < 0.1% | |
| -87.63393693 | 146 | < 0.1% | |
| -87.62750922 | 140 | < 0.1% | |
| -87.74207734 | 138 | < 0.1% | |
| Other values (183372) | 395945 | 99.4% |
| Value | Count | Frequency (%) | |
| -87.93401422 | 1 | < 0.1% | |
| -87.93399393 | 14 | < 0.1% | |
| -87.93302828 | 2 | < 0.1% | |
| -87.92726168 | 3 | < 0.1% | |
| -87.92503562 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 27 | < 0.1% | |
| -87.52458739 | 2 | < 0.1% | |
| -87.52458901 | 2 | < 0.1% | |
| -87.52464032 | 1 | < 0.1% | |
| -87.52467395 | 4 | < 0.1% |
| Distinct count | 183467 |
|---|---|
| Unique (%) | 46.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| POINT (-87.905309125103 41.976201139024) | 533 |
|---|---|
| POINT (-87.580147768689 41.791420282098) | 266 |
| POINT (-87.585971992965 41.751460603167) | 260 |
| POINT (-87.585275565077 41.722257273006) | 212 |
| POINT (-87.741645644196 41.789329323265) | 200 |
| Other values (183462) |
| Value | Count | Frequency (%) | |
| POINT (-87.905309125103 41.976201139024) | 533 | 0.1% | |
| POINT (-87.580147768689 41.791420282098) | 266 | 0.1% | |
| POINT (-87.585971992965 41.751460603167) | 260 | 0.1% | |
| POINT (-87.585275565077 41.722257273006) | 212 | 0.1% | |
| POINT (-87.741645644196 41.789329323265) | 200 | 0.1% | |
| POINT (-87.741384758605 41.754660124394) | 184 | < 0.1% | |
| POINT (-87.619928173678 41.900958919109) | 170 | < 0.1% | |
| POINT (-87.633936930688 41.742577617335) | 146 | < 0.1% | |
| POINT (-87.627509219026 41.736380045588) | 140 | < 0.1% | |
| POINT (-87.742077342959 41.792910883497) | 138 | < 0.1% | |
| Other values (183457) | 395945 | 99.4% |
Length
| Max length | 40 |
|---|---|
| Median length | 40 |
| Mean length | 39.77814332 |
| Min length | 11 |
STREET_TYPE
Categorical
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
| AVE | |
|---|---|
| ST | |
| RD | 25362 |
| BLVD | 14915 |
| DR | 14585 |
| Other values (10) | 18987 |
| Value | Count | Frequency (%) | |
| AVE | 201619 | 50.6% | |
| ST | 122726 | 30.8% | |
| RD | 25362 | 6.4% | |
| BLVD | 14915 | 3.7% | |
| DR | 14585 | 3.7% | |
| PL | 3929 | 1.0% | |
| NB | 2936 | 0.7% | |
| SB | 2817 | 0.7% | |
| PKWY | 2726 | 0.7% | |
| BROADWAY | 2119 | 0.5% | |
| Other values (5) | 4460 | 1.1% |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 2.636430986 |
| Min length | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | Unnamed: 0 | CRASH_RECORD_ID | RD_NO | CRASH_DATE | POSTED_SPEED_LIMIT | TRAFFIC_CONTROL_DEVICE | DEVICE_CONDITION | WEATHER_CONDITION | LIGHTING_CONDITION | FIRST_CRASH_TYPE | TRAFFICWAY_TYPE | LANE_CNT | ALIGNMENT | ROADWAY_SURFACE_COND | ROAD_DEFECT | REPORT_TYPE | CRASH_TYPE | INTERSECTION_RELATED_I | HIT_AND_RUN_I | DAMAGE | DATE_POLICE_NOTIFIED | PRIM_CONTRIBUTORY_CAUSE | SEC_CONTRIBUTORY_CAUSE | STREET_NO | STREET_DIRECTION | STREET_NAME | BEAT_OF_OCCURRENCE | NUM_UNITS | MOST_SEVERE_INJURY | INJURIES_TOTAL | INJURIES_FATAL | INJURIES_INCAPACITATING | INJURIES_NON_INCAPACITATING | INJURIES_REPORTED_NOT_EVIDENT | INJURIES_NO_INDICATION | INJURIES_UNKNOWN | CRASH_HOUR | CRASH_DAY_OF_WEEK | CRASH_MONTH | LATITUDE | LONGITUDE | LOCATION | STREET_TYPE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | 2 | 009e9e67203442370272e1a13d6ee51a4155dac65e583d1bdbee1fde686de7508c14ab5f205402f72644001276718917e02985561dc71b7d4bf945f09d7d47f5 | JA329216 | 06/30/2017 04:00:00 PM | 35.0 | STOP SIGN/FLASHER | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | TURNING | NOT DIVIDED | 4.0 | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | Y | 0 | OVER $1,500 | 06/30/2017 04:01:00 PM | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 8301 | S | CICERO AVE | 834.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 16 | 6 | 6 | 41.741804 | -87.740954 | POINT (-87.740953581987 41.741803598989) | AVE |
| 1 | 3 | 3 | 00e47f189660cd8ba1e85fc63061bf1d8465184393f134fb8251ed7896a4ba9ed7c984ab51a01f564d6f4133c6ef8493b1a369743a4a308d4392900a286e160f | JC194776 | 03/21/2019 10:50:00 PM | 30.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DARKNESS, LIGHTED ROAD | TURNING | NOT DIVIDED | 4.0 | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | Y | 0 | OVER $1,500 | 03/21/2019 10:52:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 8301 | S | CICERO AVE | 834.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 22 | 5 | 3 | 41.741804 | -87.740954 | POINT (-87.740953581987 41.741803598989) | AVE |
| 2 | 4 | 4 | 0126747fc9ffc0edc9a38abb83d80034f897db0f739eef57f9bc75de8f2702a4c8f6dd8e49f5c2e810e1ec428bd9532fd0e6c583ca72669da9e65fc2a0a6de12 | JB200478 | 03/26/2018 02:23:00 PM | 35.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | PARKED MOTOR VEHICLE | NOT DIVIDED | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | 0 | $501 - $1,500 | 03/26/2018 03:20:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 3999 | N | AVONDALE AVE | 1732.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 14 | 2 | 3 | 41.953647 | -87.732082 | POINT (-87.732081736006 41.953646899951) | AVE |
| 3 | 5 | 5 | 5d672ce84d5b78346be822b388604bdf9cb3fa348a5adc89501859f857e1e9308e35ececb0a56527c6e6d065cc85e4e93302c1c57a97068034116e8b23ec2f4e | JD158927 | 02/20/2020 04:45:00 PM | 35.0 | TRAFFIC SIGNAL | OTHER | CLEAR | DAWN | REAR END | T-INTERSECTION | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | Y | 0 | $501 - $1,500 | 02/20/2020 04:51:00 PM | NOT APPLICABLE | NOT APPLICABLE | 12300 | W | IRVING PARK RD | 1654.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 16 | 5 | 2 | 41.958987 | -87.933994 | POINT (-87.933993928974 41.958986950953) | RD |
| 4 | 6 | 6 | 0209e21f298984f7375742b7ef27c9880b485f41123a12b5a8eb14f01171abbbc05974399b985e05a352f801869cae0f41587f39a51994338fb82aeba853eece | JB415436 | 08/30/2018 05:45:00 PM | 30.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | TURNING | NOT DIVIDED | NaN | STRAIGHT AND LEVEL | DRY | UNKNOWN | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | Y | 0 | OVER $1,500 | 08/30/2018 05:58:00 PM | IMPROPER OVERTAKING/PASSING | IMPROPER LANE USAGE | 600 | W | DIVISION ST | 1822.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 17 | 5 | 8 | 41.903825 | -87.643286 | POINT (-87.643286359995 41.903825233976) | ST |
| 5 | 7 | 7 | 0211e1f766f3940dfa87375661d25b716655e908c320cc46910e8fa5fb1f1e6a9d4f714d21e8e401ec9e0a12190b6cd9f6dbc97d32d0c0fc966a02ae516e782f | JC301403 | 06/11/2019 08:40:00 AM | 30.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | REAR END | DIVIDED - W/MEDIAN BARRIER | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | Y | 0 | $501 - $1,500 | 06/11/2019 09:05:00 AM | UNABLE TO DETERMINE | NOT APPLICABLE | 50 | E | GARFIELD BLVD | 225.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 8 | 3 | 6 | 41.794779 | -87.623828 | POINT (-87.623828038036 41.794778764028) | BLVD |
| 6 | 8 | 8 | 02e2ed3606a50dda185f5e97c57a45552087d6fbea1c4b5f3777e0503da72279211f0518aabbeca2cd8e8ee1aca6cae3f88a0531cb62bb39ac156ca3d55e0931 | JB256393 | 05/09/2018 11:30:00 AM | 25.0 | NO CONTROLS | NO CONTROLS | RAIN | DAYLIGHT | ANGLE | NOT DIVIDED | 2.0 | STRAIGHT AND LEVEL | WET | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | NaN | 0 | OVER $1,500 | 05/09/2018 11:35:00 AM | FAILING TO YIELD RIGHT-OF-WAY | UNABLE TO DETERMINE | 9511 | S | WENTWORTH AVE | 511.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 11 | 4 | 5 | 41.721290 | -87.628510 | POINT (-87.628509593966 41.72128957001) | AVE |
| 7 | 9 | 9 | 03c8fee8a0cb0d303e972a873228b444a47b7b1ed1e2d97a8c409203dc81a9d97abc26692d325af7428a2f8f880ab0e551e763782226b9b6a0c3e19abd7ffa23 | JB317419 | 06/22/2018 07:25:00 AM | 35.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | RAIN | DAYLIGHT | TURNING | NOT DIVIDED | 6.0 | STRAIGHT AND LEVEL | WET | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | Y | 0 | OVER $1,500 | 06/22/2018 07:27:00 AM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 8301 | S | CICERO AVE | 834.0 | 2.0 | NONINCAPACITATING INJURY | 2.0 | 0.0 | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | 7 | 6 | 6 | 41.741804 | -87.740954 | POINT (-87.740953581987 41.741803598989) | AVE |
| 8 | 10 | 10 | 03def753c76d0105940f82e9eaac6f1d87683b7a574c20c10c4018a8df6b96a1a02ba2a77c1a7835bb5ffb7fd1eff3179e01226f4955266d9b7bc8d44d2faf39 | JB246843 | 05/02/2018 12:50:00 PM | 30.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | OTHER OBJECT | PARKING LOT | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | NaN | 0 | OVER $1,500 | 05/02/2018 12:53:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 1320 | E | 47TH ST | 222.0 | 1.0 | NONINCAPACITATING INJURY | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 12 | 4 | 5 | 41.809781 | -87.594213 | POINT (-87.594212812011 41.809781151018) | ST |
| 9 | 11 | 11 | 046c0f96fdf5f7384e026821bb23fdd56d610dce11247b4cf7072f4e0308cdf5865ee8f31d71792ef005d864c064aae933213ef5e4e87a9bb2247ffe0f56f245 | JC128226 | 01/24/2019 06:45:00 AM | 30.0 | NO CONTROLS | NO CONTROLS | CLEAR | DARKNESS, LIGHTED ROAD | REAR END | DIVIDED - W/MEDIAN BARRIER | 3.0 | STRAIGHT AND LEVEL | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | 0 | OVER $1,500 | 01/24/2019 03:40:00 PM | EXCEEDING SAFE SPEED FOR CONDITIONS | FOLLOWING TOO CLOSELY | 50 | E | GARFIELD BLVD | 225.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 6 | 5 | 1 | 41.794779 | -87.623828 | POINT (-87.623828038036 41.794778764028) | BLVD |
Last rows
| df_index | Unnamed: 0 | CRASH_RECORD_ID | RD_NO | CRASH_DATE | POSTED_SPEED_LIMIT | TRAFFIC_CONTROL_DEVICE | DEVICE_CONDITION | WEATHER_CONDITION | LIGHTING_CONDITION | FIRST_CRASH_TYPE | TRAFFICWAY_TYPE | LANE_CNT | ALIGNMENT | ROADWAY_SURFACE_COND | ROAD_DEFECT | REPORT_TYPE | CRASH_TYPE | INTERSECTION_RELATED_I | HIT_AND_RUN_I | DAMAGE | DATE_POLICE_NOTIFIED | PRIM_CONTRIBUTORY_CAUSE | SEC_CONTRIBUTORY_CAUSE | STREET_NO | STREET_DIRECTION | STREET_NAME | BEAT_OF_OCCURRENCE | NUM_UNITS | MOST_SEVERE_INJURY | INJURIES_TOTAL | INJURIES_FATAL | INJURIES_INCAPACITATING | INJURIES_NON_INCAPACITATING | INJURIES_REPORTED_NOT_EVIDENT | INJURIES_NO_INDICATION | INJURIES_UNKNOWN | CRASH_HOUR | CRASH_DAY_OF_WEEK | CRASH_MONTH | LATITUDE | LONGITUDE | LOCATION | STREET_TYPE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 398184 | 416188 | 416188 | e03b02d64d5d4db07c0c24fe1e9c495b4ac5b67cbe1e7334d16533b47b2a410bf1481830ec85ab046c4b391bf689476f68af6df1437f9e21cd10cacb10f7308a | JD236641 | 05/19/2020 01:00:00 PM | 25.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | REAR END | ONE-WAY | NaN | STRAIGHT AND LEVEL | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | 1 | $501 - $1,500 | 05/19/2020 02:30:00 PM | NOT APPLICABLE | NOT APPLICABLE | 1000 | S | KOLMAR AVE | 1131.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 13 | 3 | 5 | 41.869118 | -87.739401 | POINT (-87.739401314183 41.869117777281) | AVE |
| 398185 | 416189 | 416189 | f198c65371434926c14b2a63ed8792a1389fadaf675d8ee368dc5aaf1a30467a894c1412b2f099985c04308755ad76dfd1589de86c674ff6050c527539baee0d | JD236802 | 05/19/2020 03:31:00 PM | 30.0 | TRAFFIC SIGNAL | FUNCTIONING PROPERLY | CLEAR | DAYLIGHT | TURNING | FOUR WAY | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | Y | 0 | $501 - $1,500 | 05/19/2020 03:51:00 PM | IMPROPER TURNING/NO SIGNAL | NOT APPLICABLE | 2001 | E | MARQUETTE DR | 331.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 15 | 3 | 5 | 41.775563 | -87.576444 | POINT (-87.576444451178 41.775562727526) | DR |
| 398186 | 416190 | 416190 | f52f00333e5cac1530939b110da25a72de89372c032ae422467081eb937a8ff841ff2f5d73c28ededd41b765fad1e5681c1b039b5c02435bb9edb9ee97c94eab | JD236940 | 05/19/2020 06:21:00 PM | 30.0 | NO CONTROLS | NO CONTROLS | CLOUDY/OVERCAST | DAYLIGHT | SIDESWIPE SAME DIRECTION | DIVIDED - W/MEDIAN (NOT RAISED) | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | ON SCENE | NO INJURY / DRIVE AWAY | NaN | 0 | $500 OR LESS | 05/19/2020 06:21:00 PM | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 2473 | N | CLARK ST | 1935.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 0.0 | 18 | 3 | 5 | 41.927478 | -87.641450 | POINT (-87.641449775903 41.927477726852) | ST |
| 398187 | 416191 | 416191 | d97477e587b8eecbdb0dbce0a0c5462e7335a4f7da2e04c8e4799193cba69f0b887de56a831e8899031c1f7175e82a2ad8c43ba34260181a3e4e1bafda37ea88 | JD234027 | 05/16/2020 11:45:00 AM | 40.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | SIDESWIPE SAME DIRECTION | DIVIDED - W/MEDIAN BARRIER | NaN | CURVE, LEVEL | DRY | NO DEFECTS | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | NaN | 0 | OVER $1,500 | 05/16/2020 11:55:00 AM | FAILING TO YIELD RIGHT-OF-WAY | NOT APPLICABLE | 120 | N | LAKE SHORE DR SB | 114.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 11 | 7 | 5 | 41.883642 | -87.615441 | POINT (-87.615441182232 41.883641778749) | SB |
| 398188 | 416192 | 416192 | e43ffefbcb0c4518869aac0447be15af688b10f56d652adb93a204fc18d823594c6cf5e64bcf12134ee2e91a692e0434118a1367b5a5904e448f4cdbc850bfb5 | JD234946 | 05/17/2020 01:22:00 PM | 30.0 | NO CONTROLS | NO CONTROLS | RAIN | DAYLIGHT | PARKED MOTOR VEHICLE | DIVIDED - W/MEDIAN BARRIER | NaN | STRAIGHT AND LEVEL | WET | UNKNOWN | ON SCENE | INJURY AND / OR TOW DUE TO CRASH | NaN | 0 | $501 - $1,500 | 05/17/2020 01:22:00 PM | IMPROPER LANE USAGE | FAILING TO REDUCE SPEED TO AVOID CRASH | 1924 | W | GARFIELD BLVD | 932.0 | 3.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 13 | 1 | 5 | 41.794040 | -87.673019 | POINT (-87.673018619292 41.79403960152) | BLVD |
| 398189 | 416193 | 416193 | de4cbde297443228427759c6d58f40254dc8d8fcb201dc731da85d4d0dcd05fd2fbb10974bc0d17cdecd4128959af5b2fc2a4b8a0ee42f3370be201aba68a5bd | JD235651 | 05/18/2020 12:20:00 PM | 10.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | REAR TO SIDE | PARKING LOT | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | 0 | $500 OR LESS | 05/18/2020 12:32:00 PM | FAILING TO YIELD RIGHT-OF-WAY | UNABLE TO DETERMINE | 1527 | W | LAWRENCE AVE | 1912.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 12 | 2 | 5 | 41.968773 | -87.668624 | POINT (-87.668624408172 41.968772794281) | AVE |
| 398190 | 416194 | 416194 | eb65bb1c2f912fbd1a80406813bbe831df2083d483334697387d443e911400cfad731b727f3ab2ab982ab9583e12ef1bba31838e50a2d4c3979a28223b8ef00f | JD235725 | 05/18/2020 09:00:00 AM | 30.0 | UNKNOWN | UNKNOWN | UNKNOWN | UNKNOWN | PARKED MOTOR VEHICLE | UNKNOWN | NaN | STRAIGHT AND LEVEL | UNKNOWN | UNKNOWN | NOT ON SCENE (DESK REPORT) | INJURY AND / OR TOW DUE TO CRASH | NaN | 1 | OVER $1,500 | 05/18/2020 01:48:00 PM | UNABLE TO DETERMINE | NOT APPLICABLE | 4015 | N | PARKSIDE AVE | 1624.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 9 | 2 | 5 | 41.953658 | -87.768095 | POINT (-87.768095363598 41.953657967626) | AVE |
| 398191 | 416195 | 416195 | d35263055740651327a467ea3b5181fde21e1edad1e917c4096a7ca360f3ef47a2d3dc69666c6fc9bdfe7a9fdf8420654f251fcdf7c657bddc51a3a263e6eaf5 | JD236504 | 05/19/2020 02:00:00 AM | 20.0 | NO CONTROLS | NO CONTROLS | RAIN | DARKNESS, LIGHTED ROAD | PARKED MOTOR VEHICLE | ONE-WAY | NaN | STRAIGHT AND LEVEL | WET | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | 0 | $500 OR LESS | 05/19/2020 11:00:00 AM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 5700 | N | RICHMOND ST | 2011.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 2 | 3 | 5 | 41.985008 | -87.703007 | POINT (-87.70300710512 41.985008248097) | ST |
| 398192 | 416196 | 416196 | d613f48076a4221ebaebf9fc31bf396baaf18892529f3f97474e6795d01eb9545440ed9dc0d31201c554798cce001416f0aff7f4214f3848bdb211d8f89915af | JD236487 | 05/19/2020 09:40:00 AM | 30.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | PARKED MOTOR VEHICLE | NOT DIVIDED | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | 0 | $501 - $1,500 | 05/19/2020 10:36:00 AM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 7715 | S | COTTAGE GROVE AVE | 624.0 | 2.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 9 | 3 | 5 | 41.754447 | -87.605136 | POINT (-87.605136112415 41.75444668619) | AVE |
| 398193 | 416197 | 416197 | f247683bbffde5cd7d1bddad30ff42c2d3d4594ffd218dc9bdbb270b88edac4d3e2c87a077ea21bede21d27eb2d508c8c9e0a42595a81d1221035e85aeea04cd | JD236796 | 05/19/2020 01:32:00 PM | 10.0 | NO CONTROLS | NO CONTROLS | CLEAR | DAYLIGHT | OTHER OBJECT | ALLEY | NaN | STRAIGHT AND LEVEL | DRY | NO DEFECTS | NOT ON SCENE (DESK REPORT) | NO INJURY / DRIVE AWAY | NaN | 0 | OVER $1,500 | 05/19/2020 03:46:00 PM | UNABLE TO DETERMINE | UNABLE TO DETERMINE | 925 | S | INDEPENDENCE BLVD | 1133.0 | 1.0 | NO INDICATION OF INJURY | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 13 | 3 | 5 | 41.869263 | -87.719477 | POINT (-87.719476770345 41.869263306188) | BLVD |